package com.example.mapper;

import com.example.pojo.OutProduction;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;

import java.time.LocalDate;
import java.util.List;

@Mapper
public interface OutProductionMapper {
    @Insert("insert into out2 (pname,num,price,time,total,note) values (#{pname},#{num},#{price},#{time},#{total},#{note})")
    void add(OutProduction outProduction);

    Long count(String pname, int num, LocalDate begin, LocalDate end);

    List<OutProduction> page(Integer start, Integer pageSize, String pname, int num, LocalDate begin, LocalDate end);

    void delete(int[] id);
}
